<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="hk141670">pg_resgroupcapability</title>
  <body>
    <note>The <codeph>pg_resgroupcapability</codeph> system catalog table is valid only when resource group-based resource management is active.</note>
    <p>The <codeph>pg_resgroupcapability</codeph> system catalog table contains information about
      the capabilities and limits of defined Greenplum Database resource groups.
      You can join this table to the <xref
        href="pg_resgroup.xml#topic1" type="topic" format="dita"/> table by resource group object
      ID.</p>
    <p>The <codeph>pg_resgroupcapability</codeph> table, defined in the
        <codeph>pg_global</codeph> tablespace, is globally shared across all databases in
      the system.</p>
    <table id="hk141982">
      <title>pg_catalog.pg_resgroupcapability</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="105.75pt"/>
        <colspec colnum="2" colname="col2" colwidth="86pt"/>
        <colspec colnum="3" colname="col3" colwidth="122.25pt"/>
        <colspec colnum="4" colname="col4" colwidth="147pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>resgroupid</codeph>
            </entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">
              <codeph>pg_resgroup.oid</codeph>
            </entry>
            <entry colname="col4">The object ID of the associated resource group.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>reslimittype </codeph>
            </entry>
            <entry colname="col2">smallint</entry>
            <entry colname="col3">
              <codeph></codeph>
            </entry>
            <entry colname="col4">The resource group limit type:<p>0 - Unknown</p><p>1 - Concurrency</p><p>2 - CPU</p><p>3 - Memory</p><p>4 - Memory shared quota</p><p>5 - Memory spill ratio</p><p>6 - Memory auditor</p><p>7 - CPU set</p>
            </entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>value</codeph>
            </entry>
            <entry colname="col2">opaque type</entry>
            <entry colname="col3"/>
            <entry colname="col4">The specific value set for the resource limit referenced in 
              this record. This value has the fixed type <codeph>text</codeph>, and will be
              converted to a different data type depending upon the limit referenced. </entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
